<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/qq_36340642/article/details/72547495"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql中order by 可以指定排序 - qq_36340642的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql中order by 可以指定排序 - qq_36340642的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "qq_36340642";
        var blog_address = "https://blog.csdn.net/qq_36340642";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/qq_36340642/article/details/72547495"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql中order by 可以指定排序";
        var articleDesc = "mysql排序orderbyfield";
        // 第四范式所需数据
        var articleTitles = "mysql中order by 可以指定排序 - qq_36340642的博客";
        
        var nickName = "qq_36340642";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/qq_36340642/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/qq_36340642/article/details/72547495";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql中order by 可以指定排序</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年05月19日 17:01:26</span>
                    <a class="follow-nickName" href="https://me.csdn.net/qq_36340642" target="_blank">qq_36340642</a>
                    <span class="read-count">阅读数 36343</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/qq_36340642/article/details/72547495"> https://blog.csdn.net/qq_36340642/article/details/72547495</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>mysql表的排序 ORDER BY field1 [ASC [DESC]], [field2…] [ASC [DESC]],…</p>

<p>这里是想让它以 num 排序 但是 num=-1的那条数据单独为最大值 <br>
法一：field( field1,val1,val2,…) </p>

<blockquote>
  <p>这里大小顺序是 … &gt;val2 &gt;val1 &gt;field1（其他的数据） 子后向前=》从大到小 <br>
  order by field 时 Using filesort(一种速度比较慢的外部排序) , 一般不建议使用</p>
</blockquote>

<p>select * from test order by field(num,-1) asc,num asc;</p>

<p>法二：case when … then … when … then … else … end <br>
select * from test order by case when num = -1 then 1 else 0 end desc;</p>

<p><em>数据分为2个部分：</em> <br>
我认为 表中的数据分为两部分， num=-1的一条拿出来作为最大值(特殊部分)，然后其他的作为一个整体(其他部分) 然后2个部分进行排序，再用 进行一次排序可达到想要的效果 <br>
方法中的2个例子结果是一样的，但是想对来说第二种用出多些，因为它可以自由选择大、小的作为特殊部分</p>

<pre class="prettyprint"><code class=" hljs asciidoc">#表 test 共有2个字段 id,name
<span class="hljs-header">mysql&gt; desc test;
+-------+------------------+------+-----+---------+----------------+</span>
<span class="hljs-header">| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+</span>
| id    | int(10) unsigned | NO   | PRI | NULL    | auto<span class="hljs-emphasis">_increment |
| num   | int(11)          | NO   |     | 0       |                |
+-------+------------------+------+-----+---------+----------------+
mysql&gt; select * from test;
+----+-----+
| id | num |
+----+-----+
|  1 |  -1 |
|  2 |   0 |
|  3 |   1 |
|  4 |   2 |
|  5 |   3 |
|  6 |   4 |
|  7 |   5 |
+----+-----+</span></code></pre>

<hr>



<pre class="prettyprint"><code class=" hljs oxygene">    #两种方法获取到相同的排序 num=-<span class="hljs-number">1</span> 作为最大值排序
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> field(num,-<span class="hljs-number">1</span>) <span class="hljs-keyword">desc</span>;
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> <span class="hljs-keyword">case</span> when num = -<span class="hljs-number">1</span> <span class="hljs-keyword">then</span> <span class="hljs-number">1</span> <span class="hljs-keyword">else</span> <span class="hljs-number">0</span> <span class="hljs-keyword">end</span> <span class="hljs-keyword">desc</span>;
    +----+-----+
    | id | num |
    +----+-----+
    |  <span class="hljs-number">1</span> |  -<span class="hljs-number">1</span> |
    |  <span class="hljs-number">2</span> |   <span class="hljs-number">0</span> |
    |  <span class="hljs-number">3</span> |   <span class="hljs-number">1</span> |
    |  <span class="hljs-number">4</span> |   <span class="hljs-number">2</span> |
    |  <span class="hljs-number">5</span> |   <span class="hljs-number">3</span> |
    |  <span class="hljs-number">6</span> |   <span class="hljs-number">4</span> |
    |  <span class="hljs-number">7</span> |   <span class="hljs-number">5</span> |
    +----+-----+

    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> field(num,-<span class="hljs-number">1</span>) <span class="hljs-keyword">asc</span>;
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> <span class="hljs-keyword">case</span> when num = -<span class="hljs-number">1</span> <span class="hljs-keyword">then</span> <span class="hljs-number">1</span> <span class="hljs-keyword">else</span> <span class="hljs-number">0</span> <span class="hljs-keyword">end</span> <span class="hljs-keyword">asc</span>;
    +----+-----+
    | id | num |
    +----+-----+
    |  <span class="hljs-number">2</span> |   <span class="hljs-number">0</span> |
    |  <span class="hljs-number">3</span> |   <span class="hljs-number">1</span> |
    |  <span class="hljs-number">4</span> |   <span class="hljs-number">2</span> |
    |  <span class="hljs-number">5</span> |   <span class="hljs-number">3</span> |
    |  <span class="hljs-number">6</span> |   <span class="hljs-number">4</span> |
    |  <span class="hljs-number">7</span> |   <span class="hljs-number">5</span> |
    |  <span class="hljs-number">1</span> |  -<span class="hljs-number">1</span> |
    +----+-----+

    #当进行二次排序时，得到了想要的结果
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> field(num,-<span class="hljs-number">1</span>) <span class="hljs-keyword">desc</span>,num <span class="hljs-keyword">desc</span>;
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> <span class="hljs-keyword">case</span> when num = -<span class="hljs-number">1</span> <span class="hljs-keyword">then</span> <span class="hljs-number">1</span> <span class="hljs-keyword">else</span> <span class="hljs-number">0</span> <span class="hljs-keyword">end</span> <span class="hljs-keyword">desc</span>, num <span class="hljs-keyword">desc</span>;
    +----+-----+
    | id | num |
    +----+-----+
    |  <span class="hljs-number">1</span> |  -<span class="hljs-number">1</span> |
    |  <span class="hljs-number">7</span> |   <span class="hljs-number">5</span> |
    |  <span class="hljs-number">6</span> |   <span class="hljs-number">4</span> |
    |  <span class="hljs-number">5</span> |   <span class="hljs-number">3</span> |
    |  <span class="hljs-number">4</span> |   <span class="hljs-number">2</span> |
    |  <span class="hljs-number">3</span> |   <span class="hljs-number">1</span> |
    |  <span class="hljs-number">2</span> |   <span class="hljs-number">0</span> |
    +----+-----+

    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> field(num,-<span class="hljs-number">1</span>) <span class="hljs-keyword">asc</span>,num <span class="hljs-keyword">asc</span>;
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> <span class="hljs-keyword">case</span> when num = -<span class="hljs-number">1</span> <span class="hljs-keyword">then</span> <span class="hljs-number">1</span> <span class="hljs-keyword">else</span> <span class="hljs-number">0</span> <span class="hljs-keyword">end</span> <span class="hljs-keyword">asc</span>, num <span class="hljs-keyword">asc</span>;

    +----+-----+
    | id | num |
    +----+-----+
    |  <span class="hljs-number">2</span> |   <span class="hljs-number">0</span> |
    |  <span class="hljs-number">3</span> |   <span class="hljs-number">1</span> |
    |  <span class="hljs-number">4</span> |   <span class="hljs-number">2</span> |
    |  <span class="hljs-number">5</span> |   <span class="hljs-number">3</span> |
    |  <span class="hljs-number">6</span> |   <span class="hljs-number">4</span> |
    |  <span class="hljs-number">7</span> |   <span class="hljs-number">5</span> |
    |  <span class="hljs-number">1</span> |  -<span class="hljs-number">1</span> |
    +----+-----+

    #这里是 num=<span class="hljs-number">2</span> 作为最大值进行倒序排序 所以num=<span class="hljs-number">2</span>在最前面
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> <span class="hljs-keyword">case</span> when num = <span class="hljs-number">2</span> <span class="hljs-keyword">then</span> <span class="hljs-number">1</span> <span class="hljs-keyword">else</span> <span class="hljs-number">0</span> <span class="hljs-keyword">end</span> <span class="hljs-keyword">desc</span>;
    +----+-----+
    | id | num |
    +----+-----+
    |  <span class="hljs-number">4</span> |   <span class="hljs-number">2</span> |
    |  <span class="hljs-number">1</span> |  -<span class="hljs-number">1</span> |
    |  <span class="hljs-number">2</span> |   <span class="hljs-number">0</span> |
    |  <span class="hljs-number">3</span> |   <span class="hljs-number">1</span> |
    |  <span class="hljs-number">5</span> |   <span class="hljs-number">3</span> |
    |  <span class="hljs-number">6</span> |   <span class="hljs-number">4</span> |
    |  <span class="hljs-number">7</span> |   <span class="hljs-number">5</span> |
    +----+-----+

    # 这里是 num=<span class="hljs-number">2</span> 作为最小值进行正序排序 所以num=<span class="hljs-number">2</span>在最前面
    mysql&gt; <span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> test <span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span> <span class="hljs-keyword">case</span> when num = <span class="hljs-number">2</span> <span class="hljs-keyword">then</span> <span class="hljs-number">0</span> <span class="hljs-keyword">else</span> <span class="hljs-number">1</span> <span class="hljs-keyword">end</span>;
    +----+-----+
    | id | num |
    +----+-----+
    |  <span class="hljs-number">4</span> |   <span class="hljs-number">2</span> |
    |  <span class="hljs-number">1</span> |  -<span class="hljs-number">1</span> |
    |  <span class="hljs-number">2</span> |   <span class="hljs-number">0</span> |
    |  <span class="hljs-number">3</span> |   <span class="hljs-number">1</span> |
    |  <span class="hljs-number">5</span> |   <span class="hljs-number">3</span> |
    |  <span class="hljs-number">6</span> |   <span class="hljs-number">4</span> |
    |  <span class="hljs-number">7</span> |   <span class="hljs-number">5</span> |
    +----+-----+</code></pre>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_36340642/article/details/72547495","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_36340642/article/details/72547495","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="72547495">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u013034640/article/details/79554060","strategy":"BlogCommendFromAutoMl2","index":"0"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013034640/article/details/79554060","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013034640/article/details/79554060" target="_blank" title="【mysql】order by多个字段排序">
		<h4 class="text-truncate oneline">
				【<em>mysql</em>】<em>order</em> by多个字段<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-14</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013034640/article/details/79554060" target="_blank" title="【mysql】order by多个字段排序">
				<span class="desc oneline">今天遇到了两个字段排序的问题，感觉不是很清晰，所有又按照规则查询了下，总结下。count都是306的有三个。现在需要同时按照age和count排序，测试最后的排序结果。默认都是按照age和count的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013034640">来自：	<span class="blog_title"> 遇见未知的自己</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/bestallen/article/details/53726192","strategy":"BlogCommendFromAutoMl2","index":"1"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/bestallen/article/details/53726192","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bestallen/article/details/53726192" target="_blank" title="MySQL ORDER BY  排序 IF 及 IN">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> <em>ORDER</em> BY  <em>排序</em> IF 及 IN		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-18</span>
				<span class="read-num hover-hide">
					阅读数 
					8577</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bestallen/article/details/53726192" target="_blank" title="MySQL ORDER BY  排序 IF 及 IN">
				<span class="desc oneline">在做sqlzoo的时候，碰到一个SQL的排序问题，他把符合条件的单独几行，可以放在查询结果的开始，或者查询结果的尾部通过的方法就是IN语句（也可以通过IF语句）自己做了个测试，如下，这个是表的所有内容...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bestallen">来自：	<span class="blog_title"> bestallen的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_39800144/article/details/80945062","strategy":"BlogCommendFromAutoMl2","index":"2"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_39800144/article/details/80945062","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_39800144/article/details/80945062" target="_blank" title="mysql order by的坑">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>order</em> by的坑		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-06</span>
				<span class="read-num hover-hide">
					阅读数 
					556</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_39800144/article/details/80945062" target="_blank" title="mysql order by的坑">
				<span class="desc oneline">1.下面两条语句的结果是一样的SELECT*fromissue_infoORDERBYcreate_time,issue_typeDESCSELECT*fromissue_infoORDERBYcre...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_39800144">来自：	<span class="blog_title"> IT云清</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/huanchankuang3257/article/details/82931417","strategy":"BlogCommendFromAutoMl2","index":"3"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/huanchankuang3257/article/details/82931417","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/huanchankuang3257/article/details/82931417" target="_blank" title="CyclicBarrier 用法">
		<h4 class="text-truncate oneline">
				CyclicBarrier 用法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-03</span>
				<span class="read-num hover-hide">
					阅读数 
					26</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/huanchankuang3257/article/details/82931417" target="_blank" title="CyclicBarrier 用法">
				<span class="desc oneline">																															CyclicBarrier用法从字面上这个类可以理解为环形屏障，它可以协同多个线程，让多个线程在这个屏障前等待。当所有线程都达到这个屏障时...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/huanchankuang3257">来自：	<span class="blog_title"> huanchankuang3257的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/yxyx1024/article/details/41833685","strategy":"BlogCommendFromAutoMl2","index":"4"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yxyx1024/article/details/41833685","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yxyx1024/article/details/41833685" target="_blank" title="Oracle中针对中文进行排序">
		<h4 class="text-truncate oneline">
				Oracle中针对中文进行<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-09</span>
				<span class="read-num hover-hide">
					阅读数 
					251</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yxyx1024/article/details/41833685" target="_blank" title="Oracle中针对中文进行排序">
				<span class="desc oneline">在oracle9i之前,对中文的排序，是默认按2进制编码来进行排序的.9i时增加了几种新的选择:按中文拼音进行排序:SCHINESE_PINYIN_M按中文部首进行排序:SCHINESE_RADICA...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yxyx1024">来自：	<span class="blog_title"> CodePlay1024</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/80314248","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/80314248","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<a href="https://bbs.csdn.net/topics/80314248" target="_blank">
		<h4 class="text-truncate oneline">
				<em>order</em> by 能否按照<em>指定</em>顺序进行<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">01-24</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">SQL语句中 order by 可以按照指定的顺序排序否 比如 记录中 某字段值 NCH HCH ACS TWN.... 我让记录按照如上的顺序排列，OK ?</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/340142394","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/340142394","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<a href="https://bbs.csdn.net/topics/340142394" target="_blank">
		<h4 class="text-truncate oneline">
				access里怎样按<em>指定</em>顺序<em>order</em> by		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-20</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">order by charindex(','+id+ ', ',',8,1,2,3,4,5,6,7, ') 上面是sql server的。在access里怎样写？能不能实现</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42726306/article/details/86535373","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42726306/article/details/86535373","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42726306/article/details/86535373" target="_blank" title="order by 按照指定顺序排序或自定义顺序排序">
		<h4 class="text-truncate oneline">
				<em>order</em> by 按照<em>指定</em>顺序<em>排序</em>或自定义顺序<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-18</span>
				<span class="read-num hover-hide">
					阅读数 
					397</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42726306/article/details/86535373" target="_blank" title="order by 按照指定顺序排序或自定义顺序排序">
				<span class="desc oneline">今天突然接到了一个需求改动是这样的 假设A（0,1,2,3,4）字段有几个值则按照这个值进行不规则的排序（2,1,4,3,0）这样的话就会没有规律去进行排序，值可以自己进行自定义排序我用到了这个方法 ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42726306">来自：	<span class="blog_title"> weixin_42726306的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/sunyaqi_/article/details/88416158","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sunyaqi_/article/details/88416158","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sunyaqi_/article/details/88416158" target="_blank" title="order by 指定排序 两种方式">
		<h4 class="text-truncate oneline">
				<em>order</em> by <em>指定</em><em>排序</em> 两种方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-12</span>
				<span class="read-num hover-hide">
					阅读数 
					36</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sunyaqi_/article/details/88416158" target="_blank" title="order by 指定排序 两种方式">
				<span class="desc oneline">orderby指定排序两种方式idnameagesexclass1张三12男班级1–––––2李四15男班级3–––––3王五26男班级2–––––4赵六17男班级4–––––5陈七18男班级6–––...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sunyaqi_">来自：	<span class="blog_title"> sunyaqi_的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/whaxrl/article/details/50929861","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/whaxrl/article/details/50929861","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/whaxrl/article/details/50929861" target="_blank" title="mysql 使用order by field() 自定义排序">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 使用<em>order</em> by field() 自定义<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-19</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/whaxrl/article/details/50929861" target="_blank" title="mysql 使用order by field() 自定义排序">
				<span class="desc oneline">﻿﻿一、mysqlfield自定义排序函数的格式 orderbyfield(value,str1,str2,str3,str4,,,,,,strn)其中value后面的参数自定义，不限制参数个数 含义...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/whaxrl">来自：	<span class="blog_title"> whaxrl的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq2009_01/article/details/80893522","strategy":"BlogCommendFromAutoMl2","index":"10"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq2009_01/article/details/80893522","strategy":"BlogCommendFromAutoMl2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq2009_01/article/details/80893522" target="_blank" title="mysql中使用order by 和limit查询变慢解决办法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中使用<em>order</em> by 和limit查询变慢解决办法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-03</span>
				<span class="read-num hover-hide">
					阅读数 
					5491</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq2009_01/article/details/80893522" target="_blank" title="mysql中使用order by 和limit查询变慢解决办法">
				<span class="desc oneline">本文摘自：http://www.phpfensi.com/mysql/20141008/6772.html本文章来给大家介绍一篇关于mysql中使用orderby和limit查询变慢解决办法，因为在m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq2009_01">来自：	<span class="blog_title"> qq2009_01的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/linkunhao123/article/details/50373975","strategy":"BlogCommendFromAutoMl2","index":"11"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/linkunhao123/article/details/50373975","strategy":"BlogCommendFromAutoMl2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/linkunhao123/article/details/50373975" target="_blank" title="order by 自定义排序">
		<h4 class="text-truncate oneline">
				<em>order</em> by 自定义<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-21</span>
				<span class="read-num hover-hide">
					阅读数 
					2577</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/linkunhao123/article/details/50373975" target="_blank" title="order by 自定义排序">
				<span class="desc oneline">使用orderby排序，有时候不是根据字符或数字顺序，而是根据实际要求排序。例如有客户A,B,C，我希望排序结果是B,C,A，那么就要通过自定义的规则排序。第一种方法，可以构造一张映射表，将客户映射到...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/linkunhao123">来自：	<span class="blog_title"> Kingsley的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/x2145637/article/details/78435929","strategy":"BlogCommendFromAutoMl2","index":"12"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/x2145637/article/details/78435929","strategy":"BlogCommendFromAutoMl2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/x2145637/article/details/78435929" target="_blank" title="使用order by 按照指定顺序排序或自定义顺序排序">
		<h4 class="text-truncate oneline">
				使用<em>order</em> by 按照<em>指定</em>顺序<em>排序</em>或自定义顺序<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-03</span>
				<span class="read-num hover-hide">
					阅读数 
					5055</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/x2145637/article/details/78435929" target="_blank" title="使用order by 按照指定顺序排序或自定义顺序排序">
				<span class="desc oneline">我们通常需要根据客户需求对于查询出来的结果给客户提供自定义的排序方式，那么我们通常sql需要实现方式都有哪些，参考更多资料总结如下（不完善的和错误望大家指出）：一、如果我们只是对于在某个程序中的应用是...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/x2145637">来自：	<span class="blog_title"> 瓶子里的小地盘</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/aiming66/article/details/80479289","strategy":"BlogCommendFromAutoMl2","index":"13"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/aiming66/article/details/80479289","strategy":"BlogCommendFromAutoMl2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/aiming66/article/details/80479289" target="_blank" title="sql中order by 【以某个字段排序】">
		<h4 class="text-truncate oneline">
				sql中<em>order</em> by 【以某个字段<em>排序</em>】		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-28</span>
				<span class="read-num hover-hide">
					阅读数 
					7265</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/aiming66/article/details/80479289" target="_blank" title="sql中order by 【以某个字段排序】">
				<span class="desc oneline">ORDERBY语句用于对结果集进行排序。再具体的说不清了，我们直接上例子吧。现在我们有一个表，如下：实例1--asc是升序的意思默认可以不写desc是降序select*fromsellorderby商...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/aiming66">来自：	<span class="blog_title"> 程金鹏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jsd2honey/article/details/52946955","strategy":"BlogCommendFromAutoMl2","index":"14"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jsd2honey/article/details/52946955","strategy":"BlogCommendFromAutoMl2","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jsd2honey/article/details/52946955" target="_blank" title="SQL Server中使用order by charindex按指定顺序排序">
		<h4 class="text-truncate oneline">
				SQL Server中使用<em>order</em> by charindex按<em>指定</em>顺序<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-27</span>
				<span class="read-num hover-hide">
					阅读数 
					2981</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jsd2honey/article/details/52946955" target="_blank" title="SQL Server中使用order by charindex按指定顺序排序">
				<span class="desc oneline">SQLServer中使用orderbycharindex按指定顺序排序更多2016/8/1来源：SQL语句学习浏览量：694学习标签：SQLServer本文导读：在使用SQLServer数据库编程中，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jsd2honey">来自：	<span class="blog_title"> jsd2root的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jian51868/article/details/50735560","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jian51868/article/details/50735560","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jian51868/article/details/50735560" target="_blank" title="SQL的order by 高级使用·指定一条信息排列第一条">
		<h4 class="text-truncate oneline">
				SQL的<em>order</em> by 高级使用·<em>指定</em>一条信息排列第一条		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-25</span>
				<span class="read-num hover-hide">
					阅读数 
					3868</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jian51868/article/details/50735560" target="_blank" title="SQL的order by 高级使用·指定一条信息排列第一条">
				<span class="desc oneline">SQL的orderby高级使用·指定一条信息排列第一条</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jian51868">来自：	<span class="blog_title"> 我的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u014270864/article/details/51770615","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u014270864/article/details/51770615","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u014270864/article/details/51770615" target="_blank" title="mysql orderby 按照特定值排序">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>order</em>by 按照特定值<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-27</span>
				<span class="read-num hover-hide">
					阅读数 
					951</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u014270864/article/details/51770615" target="_blank" title="mysql orderby 按照特定值排序">
				<span class="desc oneline">如果想按照某个字段特定值排序可以这样写 if(b.borrow_status=2,0,1),b.borrow_status,b.add_timedesc,b.idDESC...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u014270864">来自：	<span class="blog_title"> u014270864的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/ikscher/article/details/6640562","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ikscher/article/details/6640562","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ikscher/article/details/6640562" target="_blank" title="mysql 某列指定值靠前排序">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 某列<em>指定</em>值靠前<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-28</span>
				<span class="read-num hover-hide">
					阅读数 
					7354</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ikscher/article/details/6640562" target="_blank" title="mysql 某列指定值靠前排序">
				<span class="desc oneline">单个列靠前排序：mysql某列指定值靠前排序 orderbycaseSELECT*FROM`jcxsw`.`t_company_product`orderby(   case    whenid=26...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ikscher">来自：	<span class="blog_title"> ikscher的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_14998/article/details/81961552","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_14998/article/details/81961552","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_14998/article/details/81961552" target="_blank" title="让查询结果按照指定顺序排序">
		<h4 class="text-truncate oneline">
				让查询结果按照<em>指定</em>顺序<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-12</span>
				<span class="read-num hover-hide">
					阅读数 
					12</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_14998/article/details/81961552" target="_blank" title="让查询结果按照指定顺序排序">
				<span class="desc oneline">让查询结果按照指定顺序排序----------------------------------------------------------------------表结构如下:mysql&amp;amp;g...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_14998">来自：	<span class="blog_title"> zjutsoft</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33777877/article/details/92435576","strategy":"BlogCommendFromAutoMl2","index":"19"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33777877/article/details/92435576","strategy":"BlogCommendFromAutoMl2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33777877/article/details/92435576" target="_blank" title="order by">
		<h4 class="text-truncate oneline">
				<em>order</em> by		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33777877/article/details/92435576" target="_blank" title="order by">
				<span class="desc oneline">2019独角兽企业重金招聘Python工程师标准&amp;gt;&amp;gt;&amp;gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33777877">来自：	<span class="blog_title"> weixin_33777877的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u011215669/article/details/82078812","strategy":"BlogCommendFromAutoMl2","index":"20"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u011215669/article/details/82078812","strategy":"BlogCommendFromAutoMl2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011215669/article/details/82078812" target="_blank" title="MySQL之ORDER BY 详细解析">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>之<em>ORDER</em> BY 详细解析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-26</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011215669/article/details/82078812" target="_blank" title="MySQL之ORDER BY 详细解析">
				<span class="desc oneline">1概述MySQL有两种方式可以实现ORDERBY：1.通过索引扫描生成有序的结果2.使用文件排序(filesort)围绕着这两种排序方式，我们试着理解一下ORDERBY的执行过程以及回答一些常见的问题...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011215669">来自：	<span class="blog_title"> YooHoeh的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lff642/article/details/2465730","strategy":"BlogCommendFromAutoMl2","index":"21"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lff642/article/details/2465730","strategy":"BlogCommendFromAutoMl2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lff642/article/details/2465730" target="_blank" title="关于ORDER BY 指定排列顺序">
		<h4 class="text-truncate oneline">
				关于<em>ORDER</em> BY <em>指定</em>排列顺序		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-21</span>
				<span class="read-num hover-hide">
					阅读数 
					6436</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lff642/article/details/2465730" target="_blank" title="关于ORDER BY 指定排列顺序">
				<span class="desc oneline">/**//*如何让ORDER   BY按指定的顺序排序             表a里有个列叫Type，是商品类别，就3种情况：S，A，B，如下：     id   name   type      ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lff642">来自：	<span class="blog_title"> 老虎的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u011447905/article/details/80013987","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u011447905/article/details/80013987","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011447905/article/details/80013987" target="_blank" title="MySql的几种排序方式">
		<h4 class="text-truncate oneline">
				<em>MySql</em>的几种<em>排序</em>方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-20</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011447905/article/details/80013987" target="_blank" title="MySql的几种排序方式">
				<span class="desc oneline">数据排序的情况很常见，今天介绍一下MySql的几种排序方式，是我最近有使用到的，希望能对大家有所帮助。这里先创建一张普通的表，CREATETABLE`test1`(`id`bigint(20)NOTN...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011447905">来自：	<span class="blog_title"> u011447905的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/a1124544556/article/details/89306201","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a1124544556/article/details/89306201","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a1124544556/article/details/89306201" target="_blank" title="mysql排序">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-15</span>
				<span class="read-num hover-hide">
					阅读数 
					192</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a1124544556/article/details/89306201" target="_blank" title="mysql排序">
				<span class="desc oneline">mysql排序,数值一样同排名set@curr_cnt:=0,@pre_cnt:=0,@rank:=0;selecta2,@curr_cnt:=cntascnt,@rank:=if(@pre_cnt&amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a1124544556">来自：	<span class="blog_title"> a1124544556的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391956834","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391956834","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<a href="https://bbs.csdn.net/topics/391956834" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 组合<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">05-24</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">两个排序，排序的先后的顺序不同，结果怎么差那么多，有人知道为什么回事这样吗？</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_43889681/article/details/86674645","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_43889681/article/details/86674645","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_43889681/article/details/86674645" target="_blank" title="mysql 从大到小排序">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 从大到小<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1359</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_43889681/article/details/86674645" target="_blank" title="mysql 从大到小排序">
				<span class="desc oneline">今天在使用mysql的时候，利用mysql链接的时候要清楚自己要查的主表在什么地方，还有就是orderby是从小到大排序的，从大到小排序为select*from表名orderby列desc......</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_43889681">来自：	<span class="blog_title"> weixin_43889681的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37699037/article/details/82258799","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37699037/article/details/82258799","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_37699037/article/details/82258799" target="_blank" title="MySQL排序小坑">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>排序</em>小坑		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-31</span>
				<span class="read-num hover-hide">
					阅读数 
					151</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_37699037/article/details/82258799" target="_blank" title="MySQL排序小坑">
				<span class="desc oneline">SQL中ORDERBY相同值结果乱序的具体原因  查阅了Goole和相关资料，大概总结了这种情况的原因。其实发生这种现象是“故意”设计的。  如果没有指定ORDERBY语句，则SQLServer（或任...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_37699037">来自：	<span class="blog_title"> zxr的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_7552/article/details/82640993","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_7552/article/details/82640993","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_7552/article/details/82640993" target="_blank" title="Mysql order by语句的优化">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>order</em> by语句的优化		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-19</span>
				<span class="read-num hover-hide">
					阅读数 
					16</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_7552/article/details/82640993" target="_blank" title="Mysql order by语句的优化">
				<span class="desc oneline">在某些情况中，MySQL可以使用一个索引来满足ORDERBY子句，而不需要额外的排序。where条件和orderby使用相同的索引，并且orderby的顺序和索引顺序相同，并且orderby的字段都是...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_7552">来自：	<span class="blog_title"> iteye_7552的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jam_yin/article/details/82352781","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jam_yin/article/details/82352781","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jam_yin/article/details/82352781" target="_blank" title="MYSQL排序">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em><em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-03</span>
				<span class="read-num hover-hide">
					阅读数 
					184</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jam_yin/article/details/82352781" target="_blank" title="MYSQL排序">
				<span class="desc oneline">当表是myisam时：SELECT*FROMtbl--thiswilldoa&amp;quot;tablescan&amp;quot;.IfthetablehasneverhadanyDELETEs/REPLACEs...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jam_yin">来自：	<span class="blog_title"> jam_yin的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Cfurture/article/details/78198994","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Cfurture/article/details/78198994","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Cfurture/article/details/78198994" target="_blank" title="MySQL 排序语句">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> <em>排序</em>语句		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-10</span>
				<span class="read-num hover-hide">
					阅读数 
					5622</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Cfurture/article/details/78198994" target="_blank" title="MySQL 排序语句">
				<span class="desc oneline">如果需要对读取的数据进行排序，就可以使用MySQL的 ORDERBY 子句来设定你想按哪个字段哪种方式来进行排序，再返回搜索结果。以下是SQLSELECT语句使用ORDERBY子句将查询数据排序后再返...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Cfurture">来自：	<span class="blog_title"> Cfurture的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u011162534/article/details/82874498","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u011162534/article/details/82874498","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011162534/article/details/82874498" target="_blank" title="mysql排序问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>排序</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-27</span>
				<span class="read-num hover-hide">
					阅读数 
					623</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011162534/article/details/82874498" target="_blank" title="mysql排序问题">
				<span class="desc oneline">最近开发一个功能，需要用到mysql的排序，在进行测试的时候，发现异常，没有按照预期的顺序来排序，查询后发现，原来是和字段类型有关系。数据库中排序的字段类型是varchar，而我期望的排序是int类型...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011162534">来自：	<span class="blog_title"> 一条有梦想的咸鱼</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390676968","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390676968","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<a href="https://bbs.csdn.net/topics/390676968" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>order</em>y by 默认是如何进行<em>排序</em>的呢？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-24</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">比如select * from table order by fileds limit 0,1000; 如果我的fileds都相同，那么这时候查询出来的结果会如何进行排序？</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/eagle89/article/details/81315981","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/eagle89/article/details/81315981","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/eagle89/article/details/81315981" target="_blank" title="MySQL排序原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>排序</em>原理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-31</span>
				<span class="read-num hover-hide">
					阅读数 
					1059</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/eagle89/article/details/81315981" target="_blank" title="MySQL排序原理">
				<span class="desc oneline">【目录】一、解决什么问题二、排序三、索引优化排序四、排序模式五、外部排序六、trace结果解释七、MySQL其他相关排序参数八、MySQL排序优化总结九、案例一、解决什么问题由浅入深详细说说MySQL...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/eagle89">来自：	<span class="blog_title"> eagle89的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42228338/article/details/83417411","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42228338/article/details/83417411","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42228338/article/details/83417411" target="_blank" title="MySQL实现连续排序，顺序排序，跳跃排序">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>实现连续<em>排序</em>，顺序<em>排序</em>，跳跃<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1065</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42228338/article/details/83417411" target="_blank" title="MySQL实现连续排序，顺序排序，跳跃排序">
				<span class="desc oneline">数据表如下：①DENSE_RANK()排序oracle中的dense_rank()排序排序效果如下：MySQL实现的语句代码如下：方法一：SET@RANK=0;SET@PREScore=0;SELEC...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42228338">来自：	<span class="blog_title"> Wall的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/q343509740/article/details/80611637","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/q343509740/article/details/80611637","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/q343509740/article/details/80611637" target="_blank" title="MYSQL数据排序（九）自然排序">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>数据<em>排序</em>（九）自然<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1883</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/q343509740/article/details/80611637" target="_blank" title="MYSQL数据排序（九）自然排序">
				<span class="desc oneline">假设我们有一个名为items的表，包含两列：id和item_no。要创建items表，我们使用CREATETABLE语句，sql语句如下：CREATETABLEIFNOTEXISTSitems(idI...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/q343509740">来自：	<span class="blog_title"> 有天你会让我妒忌的.</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/huanleyan/article/details/10078931","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/huanleyan/article/details/10078931","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/huanleyan/article/details/10078931" target="_blank" title="mysql中utf8_bin、utf8_general_ci、utf8_general_cs编码区别">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中utf8_bin、utf8_general_ci、utf8_general_cs编码区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-19</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/huanleyan/article/details/10078931" target="_blank" title="mysql中utf8_bin、utf8_general_ci、utf8_general_cs编码区别">
				<span class="desc oneline">utf8_unicode_ci校对规则仅部分支持Unicode校对规则算法,一些字符还是不能支持。utf8_unicode_ci不能完全支持组合的记号。utf8_general_ci是一个遗留的校对规...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/huanleyan">来自：	<span class="blog_title"> huanleyan的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/williamxww1/article/details/77841587","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/williamxww1/article/details/77841587","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/williamxww1/article/details/77841587" target="_blank" title="Mysql 排序原理">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>排序</em>原理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1156</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/williamxww1/article/details/77841587" target="_blank" title="Mysql 排序原理">
				<span class="desc oneline">filesortorderbyjoin</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/williamxww1">来自：	<span class="blog_title"> vv</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_29468573/article/details/81707848","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_29468573/article/details/81707848","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_29468573/article/details/81707848" target="_blank" title="mysql中的排序问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中的<em>排序</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-15</span>
				<span class="read-num hover-hide">
					阅读数 
					435</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_29468573/article/details/81707848" target="_blank" title="mysql中的排序问题">
				<span class="desc oneline">　　在Mysql数据库中如果某个字段定义为varchar类型，即使在插入数据时使用了数字，排序时也不会根据基本数据类型的自然排序进行排序，而是根据插入数据的先后顺序进行排序的：　　　　在这个表中id字...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_29468573">来自：	<span class="blog_title"> KnifeBlade的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/future_hui/article/details/83325936","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/future_hui/article/details/83325936","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/future_hui/article/details/83325936" target="_blank" title="Mysql 对多列进行排序">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 对多列进行<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-18</span>
				<span class="read-num hover-hide">
					阅读数 
					153</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/future_hui/article/details/83325936" target="_blank" title="Mysql 对多列进行排序">
				<span class="desc oneline">4.4.2对多列进行排序http://book.51cto.com2008-06-0416:14马军/李玉林等编著电子工业出版社我要评论(0)*摘要：《SQL语言与数据库操作技术大全：基于SQLSer...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/future_hui">来自：	<span class="blog_title"> future_hui的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_38061639/article/details/82822632","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_38061639/article/details/82822632","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/m0_38061639/article/details/82822632" target="_blank" title="MySQL select操作大全(选择SELECT&amp;排序ORDER&amp;降序ORDER&amp;选择个数LIMIT)">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> select操作大全(选择SELECT&amp;<em>排序</em><em>ORDER</em>&amp;降序<em>ORDER</em>&amp;选择个数LIMIT)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1697</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/m0_38061639/article/details/82822632" target="_blank" title="MySQL select操作大全(选择SELECT&amp;排序ORDER&amp;降序ORDER&amp;选择个数LIMIT)">
				<span class="desc oneline">在上一篇《用命令行进入MySQL&amp;amp;amp;生成样例数据库crashcourse》的基础上，练习SELECT和ORDER操作。上篇地址：https://blog.csdn.net/m0_3806...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/m0_38061639">来自：	<span class="blog_title"> m0_38061639的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/joananjin/article/details/80005880","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/joananjin/article/details/80005880","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/joananjin/article/details/80005880" target="_blank" title="Mysql排序函数">
		<h4 class="text-truncate oneline">
				<em>Mysql</em><em>排序</em>函数		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-19</span>
				<span class="read-num hover-hide">
					阅读数 
					3516</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/joananjin/article/details/80005880" target="_blank" title="Mysql排序函数">
				<span class="desc oneline">一、row_numberrow_number会为查询出来的每条记录生成一个序号，依次排序并且不会重复，row_number必须要使用over句子选择对某一列进行排序才会生成序号，row_number用...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/joananjin">来自：	<span class="blog_title"> joananjin的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lglaljj123/article/details/79864188","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lglaljj123/article/details/79864188","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lglaljj123/article/details/79864188" target="_blank" title="MySql下实现先排序后分组">
		<h4 class="text-truncate oneline">
				<em>MySql</em>下实现先<em>排序</em>后分组		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-09</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lglaljj123/article/details/79864188" target="_blank" title="MySql下实现先排序后分组">
				<span class="desc oneline">MySql中不同版本实现先排序后分组</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lglaljj123">来自：	<span class="blog_title"> Whiterock_Lelik的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_42564846/article/details/83011690","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_42564846/article/details/83011690","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_42564846/article/details/83011690" target="_blank" title="MySQL排序函数field()详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>排序</em>函数field()详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-11</span>
				<span class="read-num hover-hide">
					阅读数 
					67</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_42564846/article/details/83011690" target="_blank" title="MySQL排序函数field()详解">
				<span class="desc oneline">在日常开发过程中，排序是经常用到的，有时候有这样的需求。比如，需要在查询结果中根据某个字段的具体值来排序。如下面例子上面是一张个人信息表，假如我们想按照'seiki','iris','xut'来排序。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_42564846">来自：	<span class="blog_title"> qq_42564846的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_22585453/article/details/78892368","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_22585453/article/details/78892368","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_22585453/article/details/78892368" target="_blank" title="mysql默认的排序方式">
		<h4 class="text-truncate oneline">
				<em>mysql</em>默认的<em>排序</em>方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-25</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_22585453/article/details/78892368" target="_blank" title="mysql默认的排序方式">
				<span class="desc oneline">mysql官方的回答当你的表示myisam时：SELECT*FROMtbl--thiswilldoa&quot;tablescan&quot;.IfthetablehasneverhadanyDELETEs/REPLAC...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_22585453">来自：	<span class="blog_title"> Carry_man的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34294649/article/details/85815332","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34294649/article/details/85815332","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34294649/article/details/85815332" target="_blank" title="MySQL排序原理与MySQL5.6案例分析【转】">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>排序</em>原理与<em>MySQL</em>5.6案例分析【转】		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					9</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34294649/article/details/85815332" target="_blank" title="MySQL排序原理与MySQL5.6案例分析【转】">
				<span class="desc oneline">本文来自：http://www.cnblogs.com/cchust/p/5304594.html，其中对于自己觉得是重点的加了标记，方便自己查阅。更多详细的说明可以看沃趣科技的文章说明。前言   排...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34294649">来自：	<span class="blog_title"> weixin_34294649的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u013042707/article/details/80428532","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013042707/article/details/80428532","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013042707/article/details/80428532" target="_blank" title="mysql多个字段排序">
		<h4 class="text-truncate oneline">
				<em>mysql</em>多个字段<em>排序</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1040</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013042707/article/details/80428532" target="_blank" title="mysql多个字段排序">
				<span class="desc oneline">mysql多个字段排序SELECT*fromtestorderbyflagasc,distancedesc以flag为主升序，如果flag相同按照distance降序...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013042707">来自：	<span class="blog_title"> 猿份哥</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/fdipzone/article/details/72453553","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fdipzone/article/details/72453553","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fdipzone/article/details/72453553" target="_blank" title="mysql group by 组内排序方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em> group by 组内<em>排序</em>方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					6万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fdipzone/article/details/72453553" target="_blank" title="mysql group by 组内排序方法">
				<span class="desc oneline">mysql的groupby语法可以根据指定的规则对数据进行分组，分组就是将一个数据集划分成若干个小区域，然后再针对若干个小区域进行数据处理。本文将介绍mysql使用groupby分组时，实现组内排序的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fdipzone">来自：	<span class="blog_title"> 傲雪星枫</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_41471128/article/details/83997276","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_41471128/article/details/83997276","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_41471128/article/details/83997276" target="_blank" title="MySQL 分组排序后加编号">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 分组<em>排序</em>后加编号		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-12</span>
				<span class="read-num hover-hide">
					阅读数 
					2722</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_41471128/article/details/83997276" target="_blank" title="MySQL 分组排序后加编号">
				<span class="desc oneline">原表： 目标：将abcd分组后，每组分别加上编号 方法：首先我们先实现一个简单的效果：递增编号，理解一下第一个点SELECT@r:=@r+1ASrowNum,a.*FROMtmp_mytesta,(S...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_41471128">来自：	<span class="blog_title"> 西野圭吾</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/varyall/article/details/78874131","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/varyall/article/details/78874131","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/varyall/article/details/78874131" target="_blank" title="mysql里 filesort排序详解">
		<h4 class="text-truncate oneline">
				<em>mysql</em>里 filesort<em>排序</em>详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-22</span>
				<span class="read-num hover-hide">
					阅读数 
					2459</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/varyall/article/details/78874131" target="_blank" title="mysql里 filesort排序详解">
				<span class="desc oneline">在explain我们所使用的sql的时候，经常会遇到usingfilesort这种情况，原以为是由于有相同列值的原因引起，结果昨天看到公司的一个sql，跟同事讨论了下加上自己又做了一些测试，突然发现自...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/varyall">来自：	<span class="blog_title"> varyall的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wdergouzi/article/details/77334155","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wdergouzi/article/details/77334155","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wdergouzi/article/details/77334155" target="_blank" title="mysql 数据库排序规则">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 数据库<em>排序</em>规则		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wdergouzi/article/details/77334155" target="_blank" title="mysql 数据库排序规则">
				<span class="desc oneline">MySQL中的排序规则。在新建MySQL数据库或表的时候经常会选择字符集和排序规则。数据库用的字符集大家都知道是怎么回事，那排序规则是什么呢？排序规则：是指对指定字符集下不同字符的比较规则。其特征有以...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wdergouzi">来自：	<span class="blog_title"> PBB的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtzaAg1sNDItZWR1.html" target="_blank">
                        云计算可以干什么</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtTaQg1sNS1lZHUO0O0O.html" target="_blank">
                        哪里可以学python</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/qq_36340642">
              <img src="https://avatar.csdn.net/A/7/E/3_qq_36340642.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/3.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/qq_36340642"  class="" id="uid">qq_36340642</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="7">
                        <dt><a href="https://blog.csdn.net/qq_36340642?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/qq_36340642?t=1"><span class="count">7</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="1">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">1</span></dd>
        </dl>
        <dl class="text-center" title="8">
            <dt>喜欢</dt>
            <dd><span class="count">8</span></dd>
        </dl>
        <dl class="text-center" title="2">
            <dt>评论</dt>
            <dd><span class="count">2</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="53632">
                5万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="333">
                333            </dd>
        </dl>
        <dl title="300481">
            <dt>排名：</dt>
            <dd>30万+</dd>
        </dl>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/qq_36340642">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_36340642/article/details/85694858" target="_blank" >
                                        ArcGIS JS API 实现路径轨迹回放                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_36340642/article/details/79403130" target="_blank" >
                                        鼠标拖拽，滚动条滚动                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_36340642/article/details/79363711" target="_blank" >
                                        php base64编码 加解密 手动实现                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_36340642/article/details/79353179" target="_blank" >
                                        table 标签中 头部固定，body部分滚动                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_36340642/article/details/79353173" target="_blank" >
                                        文字超过设定宽度自动显示省略号                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_36340642/article/category/6452216">
                    <span class="title oneline">正则表达式</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_36340642/article/category/6910877">
                    <span class="title oneline">css</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_36340642/article/category/6910909">
                    <span class="title oneline">js</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_36340642/article/category/6927717">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_36340642/article/category/7465102">
                    <span class="title oneline">php</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideArchive" class="aside-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_36340642/article/month/2019/01">
                    2019年1月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_36340642/article/month/2018/02">
                    2018年2月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_36340642/article/month/2017/06">
                    2017年6月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_36340642/article/month/2017/05">
                    2017年5月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_36340642/article/month/2016/10">
                    2016年10月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/qq_36340642/article/details/72547495" >
                                                mysql中order by 可以指定排序                    </a>
					<p class="read">阅读数 <span>36342</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_36340642/article/details/79352876" >
                                                正则表达式修饰符 i、g、m、s、U、x、a、D、e 等。                    </a>
					<p class="read">阅读数 <span>12827</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_36340642/article/details/79363711" >
                                                php base64编码 加解密 手动实现                    </a>
					<p class="read">阅读数 <span>1226</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_36340642/article/details/79353179" >
                                                table 标签中 头部固定，body部分滚动                    </a>
					<p class="read">阅读数 <span>825</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_36340642/article/details/85694858" >
                                                ArcGIS JS API 实现路径轨迹回放                    </a>
					<p class="read">阅读数 <span>815</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_36340642/article/details/72547495#comments">mysql中order by 可以...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/CodeMan_X" class="user-name" target="_blank">CodeMan_X：</a>点赞                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_36340642/article/details/72547495#comments">mysql中order by 可以...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/kk1946n" class="user-name" target="_blank">kk1946n：</a>mark一下                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">2</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments long-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
						2				</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/qq_36340642/article/details/71531872" title="鼠标拖拽事件">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/qq_36340642/article/details/72852421" title="LAMP 环境手动搭建">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/qq_36340642/article/details/71531872" title="鼠标拖拽事件">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/qq_36340642/article/details/72852421" title="LAMP 环境手动搭建">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "72547495";
    var commentscount = 2;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/qq_36340642/article/details/72547495";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql中order by 可以指定排序 - qq_36340642的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","order","\u53ef\u4ee5","\u6307\u5b9a","\u6392\u5e8f"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
